<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
body,td,th {
	font-size: 16px;
}
.table1 {
	border-top:#039 1px solid;
	border-right:#039 1px solid;
}
.table1 {
	border-bottom:#039 1px solid;
	border-left:#039 1px solid;
	padding:3px 4px 3px 4px;
}

</style>
</head>

<body>
<?php
$conn=mysql_connect('127.0.0.1:3306','betty','123qwe');
mysql_query("SET NAMES 'utf8'",$conn);
mysql_select_db('betty',$conn);
$sql="SElECT * FROM `scord1`";
$return=mysql_query($sql,$conn);
if(!$return){
	die('查询失败');
}
?>
 <form id="form1" name="form1" method="post" action="">
<table width="500"  border="1" cellpadding="0" cellspacing="0" class="table1">
  <tr align="center">
    <td>选择</td>
    <td>ID</td>
    <td>姓名</td>
    <td>性别</td>
    <td>分数</td>
    <td>操作</td>
  </tr>
<?php
while($row=mysql_fetch_array($return,MYSQL_BOTH)){
?>
  <tr align="center">
    <td><input type="checkbox" name="checkbox" id="checkbox" /></td>
    <td><?php echo $row['id'];?></td>
    <td><?php echo $row['name'];?></td>
    <td><?php echo $row['gender'];
if($row['gender']==1){
	echo '男';
}else if($row['gender']==2){
	echo '女';
}else{
	echo '未知('.$row['gender'].')';
}
?>
    </td>
    <td><?php echo $row['point'];?></td>
    <td><a href="#12">修改</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="#224">删除</a><br /></td>
  </tr>
<?php
}
?>
</table>
</form>
</body>
</html>